﻿USE [OrderEntryManagement];
GO
-------ProductionStatus--------------

INSERT INTO "ProductionStatus" VALUES('Order Accepted')
INSERT INTO "ProductionStatus" VALUES('Order sent to QA')
INSERT INTO "ProductionStatus" VALUES('Order sent to Copyright')
INSERT INTO "ProductionStatus" VALUES('Order sent to Creative')
INSERT INTO "ProductionStatus" VALUES('Order scheduled for Production')
INSERT INTO "ProductionStatus" VALUES('Order out of Production')
INSERT INTO "ProductionStatus" VALUES('Special Order')
INSERT INTO "ProductionStatus" VALUES('Order scheduled to broadcast')
INSERT INTO "ProductionStatus" VALUES('Order Closed')
GO

-------OrderTypes--------------

INSERT "OrderTypes" VALUES('Digital advertising')
INSERT "OrderTypes" VALUES('Radio advertising')
INSERT "OrderTypes" VALUES('Television advertising ')
INSERT "OrderTypes" VALUES('Music advertising')
INSERT "OrderTypes" VALUES('Infomercials')
INSERT "OrderTypes" VALUES('Online advertising')
INSERT "OrderTypes" VALUES('Product placements')
INSERT "OrderTypes" VALUES('Press advertising')
INSERT "OrderTypes" VALUES('Billboard advertising')
INSERT "OrderTypes" VALUES('In-store advertising')
INSERT "OrderTypes" VALUES('Celebrity branding')
GO

-------AssetTypes--------------

INSERT "AssetTypes" VALUES('Radio')
INSERT "AssetTypes" VALUES('Television')
INSERT "AssetTypes" VALUES('Mobile')
INSERT "AssetTypes" VALUES('Shirts')
INSERT "AssetTypes" VALUES('Popups')
INSERT "AssetTypes" VALUES('Trade Journal')
INSERT "AssetTypes" VALUES('Paper')
INSERT "AssetTypes" VALUES('Billboard')
INSERT "AssetTypes" VALUES('Magazine')
INSERT "AssetTypes" VALUES('Classified')
GO

-------Customers--------------

INSERT "Customers" VALUES('Maria Anders','Obere Str. 57, Berlin, Germany')						
INSERT "Customers" VALUES('Ana Trujillo','Avda. de la Constitución 2222, México D.F., Mexico')						
INSERT "Customers" VALUES('Antonio Moreno','Mataderos  2312, México D.F., Mexico')						
INSERT "Customers" VALUES('Thomas Hardy','120 Hanover Sq., London, UK')						
INSERT "Customers" VALUES('Christina Berglund','Berguvsvägen  8, Luleå, Sweden')						
INSERT "Customers" VALUES('Hanna Moos','Forsterstr. 57, Mannheim, Germany')						
INSERT "Customers" VALUES('Frédérique Citeaux','24, place Kléber, Strasbourg, France')						
INSERT "Customers" VALUES('Martín Sommer','C/ Araquil, 67, Madrid, Spain')						
INSERT "Customers" VALUES('Laurence Lebihan','12, rue des Bouchers, Marseille, France')						
INSERT "Customers" VALUES('Elizabeth Lincoln','23 Tsawassen Blvd., Tsawassen, Canada')						
INSERT "Customers" VALUES('Victoria Ashworth','Fauntleroy Circus, London, UK')						
INSERT "Customers" VALUES('Patricio Simpson','Cerrito 333, Buenos Aires, Argentina')						
INSERT "Customers" VALUES('Francisco Chang','Sierras de Granada 9993, México D.F., Mexico')						
INSERT "Customers" VALUES('Yang Wang','Hauptstr. 29, Bern, Switzerland')						
INSERT "Customers" VALUES('Pedro Afonso','Av. dos Lusíadas, 23, Sao Paulo, Brazil')						
INSERT "Customers" VALUES('Elizabeth Brown','Berkeley Gardens 12  Brewery, London, UK')						
INSERT "Customers" VALUES('Sven Ottlieb','Walserweg 21, Aachen, Germany')						
INSERT "Customers" VALUES('Janine Labrune','67, rue des Cinquante Otages, Nantes, France')						
INSERT "Customers" VALUES('Ann Devon','35 King George, London, UK')						
INSERT "Customers" VALUES('Roland Mendel','Kirchgasse 6, Graz, Austria')						
INSERT "Customers" VALUES('Aria Cruz','Rua Orós, 92, Sao Paulo, Brazil')						
INSERT "Customers" VALUES('Diego Roel','C/ Moralzarzal, 86, Madrid, Spain')						
INSERT "Customers" VALUES('Martine Rancé','184, chaussée de Tournai, Lille, France')						
INSERT "Customers" VALUES('Maria Larsson','Åkergatan 24, Bräcke, Sweden')						
INSERT "Customers" VALUES('Peter Franken','Berliner Platz 43, München, Germany')						
INSERT "Customers" VALUES('Carine Schmitt','54, rue Royale, Nantes, France')						
INSERT "Customers" VALUES('Paolo Accorti','Via Monte Bianco 34, Torino, Italy')						
INSERT "Customers" VALUES('Lino Rodriguez','Jardim das rosas n. 32, Lisboa, Portugal')						
INSERT "Customers" VALUES('Eduardo Saavedra','Rambla de Cataluña, 23, Barcelona, Spain')						
INSERT "Customers" VALUES('José Pedro Freyre','C/ Romero, 33, Sevilla, Spain')						
INSERT "Customers" VALUES('André Fonseca','Av. Brasil, 442, Campinas, Brazil')						
INSERT "Customers" VALUES('Howard Snyder','2732 Baker Blvd., Eugene, USA')						
INSERT "Customers" VALUES('Manuel Pereira','5ª Ave. Los Palos Grandes, Caracas, Venezuela')						
INSERT "Customers" VALUES('Mario Pontes','Rua do Paço, 67, Rio de Janeiro, Brazil')						
INSERT "Customers" VALUES('Carlos Hernández','Carrera 22 con Ave. Carlos Soublette #8-35, San Cristóbal, Venezuela')						
INSERT "Customers" VALUES('Yoshi Latimer','City Center Plaza 516 Main St., Elgin, USA')						
INSERT "Customers" VALUES('Patricia McKenna','8 Johnstown Road, Cork, Ireland')						
INSERT "Customers" VALUES('Helen Bennett','Garden House Crowther Way, Cowes, UK')						
INSERT "Customers" VALUES('Philip Cramer','Maubelstr. 90, Brandenburg, Germany')						
INSERT "Customers" VALUES('Daniel Tonini','67, avenue de l''Europe, Versailles, France')						
INSERT "Customers" VALUES('Annette Roulet','1 rue Alsace-Lorraine, Toulouse, France')						
INSERT "Customers" VALUES('Yoshi Tannamuri','1900 Oak St., Vancouver, Canada')						
INSERT "Customers" VALUES('John Steel','12 Orchestra Terrace, Walla Walla, USA')						
INSERT "Customers" VALUES('Renate Messner','Magazinweg 7, Frankfurt a.M., Germany')						
INSERT "Customers" VALUES('Jaime Yorres','87 Polk St. Suite 5, San Francisco, USA')						
INSERT "Customers" VALUES('Carlos González','Carrera 52 con Ave. Bolívar #65-98 Llano Largo, Barquisimeto, Venezuela')						
INSERT "Customers" VALUES('Felipe Izquierdo','Ave. 5 de Mayo Porlamar, I. de Margarita, Venezuela')						
INSERT "Customers" VALUES('Fran Wilson','89 Chiaroscuro Rd., Portland, USA')						
INSERT "Customers" VALUES('Giovanni Rovelli','Via Ludovico il Moro 22, Bergamo, Italy')						
INSERT "Customers" VALUES('Catherine Dewey','Rue Joseph-Bens 532, Bruxelles, Belgium')						
INSERT "Customers" VALUES('Jean Fresnière','43 rue St. Laurent, Montréal, Canada')						
INSERT "Customers" VALUES('Alexander Feuer','Heerstr. 22, Leipzig, Germany')						
INSERT "Customers" VALUES('Simon Crowther','South House 300 Queensbridge, London, UK')						
INSERT "Customers" VALUES('Yvonne Moncada','Ing. Gustavo Moncada 8585 Piso 20-A, Buenos Aires, Argentina')						
INSERT "Customers" VALUES('Rene Phillips','2743 Bering St., Anchorage, USA')						
INSERT "Customers" VALUES('Henriette Pfalzheim','Mehrheimerstr. 369, Köln, Germany')						
INSERT "Customers" VALUES('Marie Bertrand','265, boulevard Charonne, Paris, France')						
INSERT "Customers" VALUES('Guillermo Fernández','Calle Dr. Jorge Cash 321, México D.F., Mexico')						
INSERT "Customers" VALUES('Georg Pipps','Geislweg 14, Salzburg, Austria')						
INSERT "Customers" VALUES('Isabel de Castro','Estrada da saúde n. 58, Lisboa, Portugal')						
INSERT "Customers" VALUES('Bernardo Batista','Rua da Panificadora, 12, Rio de Janeiro, Brazil')						
INSERT "Customers" VALUES('Lúcia Carvalho','Alameda dos Canàrios, 891, Sao Paulo, Brazil')						
INSERT "Customers" VALUES('Horst Kloss','Taucherstraße 10, Cunewalde, Germany')						
INSERT "Customers" VALUES('Sergio Gutiérrez','Av. del Libertador 900, Buenos Aires, Argentina')						
INSERT "Customers" VALUES('Paula Wilson','2817 Milton Dr., Albuquerque, USA')						
INSERT "Customers" VALUES('Maurizio Moroni','Strada Provinciale 124, Reggio Emilia, Italy')						
INSERT "Customers" VALUES('Janete Limeira','Av. Copacabana, 267, Rio de Janeiro, Brazil')						
INSERT "Customers" VALUES('Michael Holz','Grenzacherweg 237, Genève, Switzerland')						
INSERT "Customers" VALUES('Alejandra Camino','Gran Vía, 1, Madrid, Spain')						
INSERT "Customers" VALUES('Jonas Bergulfsen','Erling Skakkes gate 78, Stavern, Norway')						
INSERT "Customers" VALUES('Jose Pavarotti','187 Suffolk Ln., Boise, USA')						
INSERT "Customers" VALUES('Hari Kumar','90 Wadhurst Rd., London, UK')						
INSERT "Customers" VALUES('Jytte Petersen','Vinbæltet 34, Kobenhavn, Denmark')						
INSERT "Customers" VALUES('Dominique Perrier','25, rue Lauriston, Paris, France')						
INSERT "Customers" VALUES('Art Braunschweiger','P.O. Box 555, Lander, USA')						
INSERT "Customers" VALUES('Pascale Cartrain','Boulevard Tirou, 255, Charleroi, Belgium')						
INSERT "Customers" VALUES('Liz Nixon','89 Jefferson Way Suite 2, Portland, USA')						
INSERT "Customers" VALUES('Liu Wong','55 Grizzly Peak Rd., Butte, USA')						
INSERT "Customers" VALUES('Karin Josephs','Luisenstr. 48, Münster, Germany')						
INSERT "Customers" VALUES('Miguel Angel Paolino','Avda. Azteca 123, México D.F., Mexico')						
INSERT "Customers" VALUES('Anabela Domingues','Av. Inês de Castro, 414, Sao Paulo, Brazil')						
INSERT "Customers" VALUES('Helvetius Nagy','722 DaVinci Blvd., Kirkland, USA')						
INSERT "Customers" VALUES('Palle Ibsen','Smagsloget 45, Århus, Denmark')						
INSERT "Customers" VALUES('Mary Saveley','2, rue du Commerce, Lyon, France')						
INSERT "Customers" VALUES('Paul Henriot','59 rue de l''Abbaye, Reims, France')						
INSERT "Customers" VALUES('Rita Müller','Adenauerallee 900, Stuttgart, Germany')						
INSERT "Customers" VALUES('Pirkko Koskitalo','Torikatu 38, Oulu, Finland')						
INSERT "Customers" VALUES('Paula Parente','Rua do Mercado, 12, Resende, Brazil')						
INSERT "Customers" VALUES('Karl Jablonski','305 - 14th Ave. S. Suite 3B, Seattle, USA')						
INSERT "Customers" VALUES('Matti Karttunen','Keskuskatu 45, Helsinki, Finland')						
INSERT "Customers" VALUES('Zbyszek Piestrzeniewicz','ul. Filtrowa 68, Warszawa, Poland')
GO

-------Assets--------------						
														
INSERT "Assets" VALUES(cast(RAND()* 10 as int) +1,'Assest1')
INSERT "Assets" VALUES(cast(RAND()* 10 as int) +1,'Assest2')
INSERT "Assets" VALUES(cast(RAND()* 10 as int) +1,'Assest3')
INSERT "Assets" VALUES(cast(RAND()* 10 as int) +1,'Assest4')
INSERT "Assets" VALUES(cast(RAND()* 10 as int) +1,'Assest5')
INSERT "Assets" VALUES(cast(RAND()* 10 as int) +1,'Assest6')
INSERT "Assets" VALUES(cast(RAND()* 10 as int) +1,'Assest7')
INSERT "Assets" VALUES(cast(RAND()* 10 as int) +1,'Assest8')
INSERT "Assets" VALUES(cast(RAND()* 10 as int) +1,'Assest9')
INSERT "Assets" VALUES(cast(RAND()* 10 as int) +1,'Assest10')
GO

-------Orders--------------	
INSERT "Orders" VALUES(cast(RAND()* 90 as int) +1,cast(RAND()* 10 as int) +1,getdate(),cast(RAND()* 10 as int) +1,10,cast(RAND()* 10 as int) +1)
INSERT "Orders" VALUES(cast(RAND()* 90 as int) +1,cast(RAND()* 10 as int) +1,getdate(),cast(RAND()* 10 as int) +1,10,cast(RAND()* 10 as int) +1)
INSERT "Orders" VALUES(cast(RAND()* 90 as int) +1,cast(RAND()* 10 as int) +1,getdate(),cast(RAND()* 10 as int) +1,10,cast(RAND()* 10 as int) +1)
INSERT "Orders" VALUES(cast(RAND()* 90 as int) +1,cast(RAND()* 10 as int) +1,getdate(),cast(RAND()* 10 as int) +1,10,cast(RAND()* 10 as int) +1)
INSERT "Orders" VALUES(cast(RAND()* 90 as int) +1,cast(RAND()* 10 as int) +1,getdate(),cast(RAND()* 10 as int) +1,10,cast(RAND()* 10 as int) +1)
INSERT "Orders" VALUES(cast(RAND()* 90 as int) +1,cast(RAND()* 10 as int) +1,getdate(),cast(RAND()* 10 as int) +1,10,cast(RAND()* 10 as int) +1)
INSERT "Orders" VALUES(cast(RAND()* 90 as int) +1,cast(RAND()* 10 as int) +1,getdate(),cast(RAND()* 10 as int) +1,10,cast(RAND()* 10 as int) +1)
GO
